Sa1098TWork

Logical Entity Name | Sa1098TWork
Default Table Name | Sa1098TWork
Physical Only | NO
Owner | dbo
Definition |
Note |

Sa1098TWork Columns

ColumnName | Domain | Datatype | NULL | Definition
Sa1098TWorkID |  | int | NO |
SyStudentID1 |  | int | YES |
SyStudentID2 |  | int | YES |
SyStudentID3 |  | int | YES |
FirstName1 |  | char(40) | YES |
FirstName2 |  | char(40) | YES |
FirstName3 |  | char(40) | YES |
MI1 |  | char(1) | YES |
Mi2 |  | char(1) | YES |
Mi3 |  | char(1) | YES |
LastName1 |  | char(40) | YES |
LastName2 |  | char(40) | YES |
LastName3 |  | char(40) | YES |
Addr11 |  | char(128) | YES |
Addr12 |  | char(128) | YES |
Addr13 |  | char(128) | YES |
Addr21 |  | char(60) | YES |
Addr22 |  | char(60) | YES |
Addr23 |  | char(60) | YES |
City1 |  | char(40) | YES |
City2 |  | char(40) | YES |
City3 |  | char(40) | YES |
State1 |  | char(2) | YES |
State2 |  | char(2) | YES |
State3 |  | char(2) | YES |
Zip1 |  | char(10) | YES |
Zip2 |  | char(10) | YES |
Zip3 |  | char(10) | YES |
SSN1 |  | varchar(30) | YES |
SSN2 |  | varchar(30) | YES |
SSN3 |  | varchar(30) | YES |
CampName1 |  | char(60) | YES |
CampName2 |  | char(60) | YES |
CampName3 |  | char(60) | YES |
CampAddr11 |  | char(60) | YES |
CampAddr12 |  | char(60) | YES |
CampAddr13 |  | char(60) | YES |
CampAddr21 |  | char(60) | YES |
CampAddr22 |  | char(60) | YES |
CampAddr23 |  | char(60) | YES |
CampCity1 |  | char(40) | YES |
CampCity2 |  | char(40) | YES |
CampCity3 |  | char(40) | YES |
CampState1 |  | char(2) | YES |
CampState2 |  | char(2) | YES |
CampState3 |  | char(2) | YES |
CampZip1 |  | char(10) | YES |
CampZip2 |  | char(10) | YES |
CampZip3 |  | char(10) | YES |
CampPhone1 |  | varchar(25) | YES |
CampPhone2 |  | varchar(25) | YES |
CampPhone3 |  | varchar(25) | YES |
TIN1 |  | char(10) | YES |
TIN2 |  | char(10) | YES |
TIN3 |  | char(10) | YES |
SyCampusID1 |  | int | YES |
SyCampusID2 |  | int | YES |
SyCampusID3 |  | int | YES |
StartDate1 |  | datetime | YES |
StartDate2 |  | datetime | YES |
StartDate3 |  | datetime | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserId |  | int | NO |
AttStatCode1 |  | char(8) | YES |
AttStatCode2 |  | char(8) | YES |
AttStatCode3 |  | char(8) | YES |
AdGradeLevelID1 |  | int | YES |
AdGradeLevelID2 |  | int | YES |
AdGradeLevelID3 |  | int | YES |
IncludeMarch1 |  | bit | YES |
IncludeMarch2 |  | bit | YES |
IncludeMarch3 |  | bit | YES |
Amount1 |  | money | YES |
Amount2 |  | money | YES |
Amount3 |  | money | YES |
Scholarship1 |  | money | YES |
Scholarship2 |  | money | YES |
Scholarship3 |  | money | YES |
ts |  | timestamp | NO |
ReportMethodChanged1 |  | bit | NO |
ReportMethodChanged2 |  | bit | NO |
ReportMethodChanged3 |  | bit | NO |
Year1 |  | char(4) | YES |
Year2 |  | char(4) | YES |
Year3 |  | char(4) | YES |
AmountPrevYear1 |  | money | YES |
AmountPrevYear2 |  | money | YES |
AmountPrevYear3 |  | money | YES |
SShipPrevYear1 |  | money | YES |
SShipPrevYear2 |  | money | YES |
SShipPrevYear3 |  | money | YES |

Sa1098TWork Primary and Unique Keys

Key Name | Key Type | Keys
Sa1098TWork_Sa1098TWorkID_U_C_IDX | PrimaryKey | Sa1098TWorkID

Sa1098TWork Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

Sa1098TWork Check Constraints

Check Constraint Name | CheckConstraint

Sa1098TWork Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

Sa1098TWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Sa1098TWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.Sa1098TWork | NO |  |  |

Sa1098TWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

Sa1098TWork Data Movement Rules

Name | Type | Rule Text/Value